/*
Navicat MySQL Data Transfer

Source Server         : local
Source Server Version : 50529
Source Host           : localhost:3306
Source Database       : test

Target Server Type    : MYSQL
Target Server Version : 50529
File Encoding         : 65001

Date: 2021-06-02 21:31:13
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `acc_info`
-- ----------------------------
DROP TABLE IF EXISTS `acc_info`;
CREATE TABLE `acc_info` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`acc_no`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '账号' ,
`acc_pwd`  varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码' ,
`acc_name`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=8

;

-- ----------------------------
-- Records of acc_info
-- ----------------------------
BEGIN;
INSERT INTO `acc_info` VALUES ('1', 'admin', 'admin', '张三');
COMMIT;

-- ----------------------------
-- Table structure for `category_info`
-- ----------------------------
DROP TABLE IF EXISTS `category_info`;
CREATE TABLE `category_info` (
`id`  int(10) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`name`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称' ,
`parentId`  int(10) NOT NULL COMMENT '父级目录id' ,
`type`  int(11) NULL DEFAULT NULL COMMENT '级别(1:一级 2：二级 3：三级)' ,
`iconClass`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `PK__EASYBUY___9EC2A4E236B12243` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=697

;

-- ----------------------------
-- Records of category_info
-- ----------------------------
BEGIN;
INSERT INTO `category_info` VALUES ('548', '化妆品', '0', '1', ''), ('628', '家用商品', '0', '1', ''), ('654', '面部护理', '548', '2', ''), ('655', '少女派', '654', '3', ''), ('656', '餐具', '628', '2', ''), ('657', '卫具', '628', '2', ''), ('658', '叉子', '656', '3', ''), ('659', '锅', '656', '3', ''), ('660', '进口食品,生鲜', '0', '1', ''), ('661', '零食/糖果/巧克力', '660', '2', ''), ('662', '坚果', '661', '3', ''), ('663', '蜜饯', '661', '3', ''), ('669', '孕期教育', '546', '3', ''), ('670', '电子商品', '0', '1', ''), ('671', '手机', '670', '2', ''), ('672', '华为手机', '671', '3', ''), ('673', '联想手机', '671', '3', ''), ('674', '手环', '670', '2', ''), ('675', '小米手环', '674', '3', ''), ('676', '保健食品', '0', '1', ''), ('677', '老年保健品', '676', '2', ''), ('678', '中年营养品', '676', '2', ''), ('679', '儿童保健品', '676', '2', ''), ('680', '脑白金', '677', '3', ''), ('681', '箱包', '0', '1', ''), ('682', '旅行箱', '681', '2', ''), ('683', '手提箱', '681', '2', ''), ('684', '大型', '683', '3', ''), ('685', '小型', '683', '3', ''), ('686', '中型', '683', '3', ''), ('687', '大型', '682', '3', ''), ('688', '中型', '682', '3', ''), ('689', '小型', '682', '3', ''), ('690', '电脑', '670', '2', ''), ('691', '联想电脑', '690', '3', ''), ('692', '刀叉', '656', '3', null), ('693', '碗筷', '656', '3', null), ('696', '客厅专用', '628', '2', '');
COMMIT;

-- ----------------------------
-- Table structure for `classes_info`
-- ----------------------------
DROP TABLE IF EXISTS `classes_info`;
CREATE TABLE `classes_info` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`classes_name`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '班级名称' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of classes_info
-- ----------------------------
BEGIN;
INSERT INTO `classes_info` VALUES ('1', '1班'), ('2', '3班'), ('3', '5班'), ('4', '7班');
COMMIT;

-- ----------------------------
-- Table structure for `easybuy_order`
-- ----------------------------
DROP TABLE IF EXISTS `easybuy_order`;
CREATE TABLE `easybuy_order` (
`id`  int(11) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`userId`  int(255) NULL DEFAULT NULL COMMENT '用户主键' ,
`loginName`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
`userAddress`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户地址' ,
`createTime`  datetime NULL DEFAULT NULL COMMENT '创建时间' ,
`cost`  float NULL DEFAULT NULL COMMENT '总消费' ,
`serialNumber`  varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '订单号' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=4

;

-- ----------------------------
-- Records of easybuy_order
-- ----------------------------
BEGIN;
INSERT INTO `easybuy_order` VALUES ('1', '18', 'shangzezhong', '北京市花园路小区', '2016-06-02 14:51:46', '1721', '60B7487F47F9434EAA5FD1D9E22CB06C'), ('2', '18', 'shangzezhong', '北京市海淀区成府路', '2016-06-02 14:52:49', '8596', '8EF5E1557D55413781658A65FC301B8A'), ('3', '2', 'admin', '北京市海淀区大有庄', '2016-06-03 11:41:09', '456', '51718726C1274CC59504AB4E6FD64BA0');
COMMIT;

-- ----------------------------
-- Table structure for `easybuy_order_detail`
-- ----------------------------
DROP TABLE IF EXISTS `easybuy_order_detail`;
CREATE TABLE `easybuy_order_detail` (
`id`  int(10) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`orderId`  int(10) NOT NULL COMMENT '订单主键' ,
`productId`  int(10) NOT NULL COMMENT '商品主键' ,
`quantity`  int(10) NOT NULL COMMENT '数量' ,
`cost`  float NOT NULL COMMENT '消费' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `PK__EASYBUY___66E1BD8E2F10007B` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=10

;

-- ----------------------------
-- Records of easybuy_order_detail
-- ----------------------------
BEGIN;
INSERT INTO `easybuy_order_detail` VALUES ('1', '1', '733', '5', '760'), ('2', '1', '734', '4', '608'), ('3', '1', '735', '1', '152'), ('4', '1', '738', '1', '45'), ('5', '1', '739', '1', '156'), ('6', '2', '755', '1', '8596'), ('7', '3', '733', '1', '152'), ('8', '3', '734', '1', '152'), ('9', '3', '735', '1', '152');
COMMIT;

-- ----------------------------
-- Table structure for `easybuy_product`
-- ----------------------------
DROP TABLE IF EXISTS `easybuy_product`;
CREATE TABLE `easybuy_product` (
`id`  int(10) NOT NULL AUTO_INCREMENT COMMENT '主键' ,
`name`  varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '名称' ,
`description`  varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述' ,
`price`  float NOT NULL COMMENT '价格' ,
`stock`  int(10) NOT NULL COMMENT '库存' ,
`categoryLevel1Id`  int(10) NULL DEFAULT NULL COMMENT '分类1' ,
`categoryLevel2Id`  int(10) NULL DEFAULT NULL COMMENT '分类2' ,
`categoryLevel3Id`  int(10) NULL DEFAULT NULL COMMENT '分类3' ,
`fileName`  varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名称' ,
`isDelete`  int(1) NULL DEFAULT 0 COMMENT '是否删除(1：删除 0：未删除)' ,
PRIMARY KEY (`id`),
UNIQUE INDEX `PK__EASYBUY___94F6E55132E0915F` (`id`) USING BTREE 
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=771

;

-- ----------------------------
-- Records of easybuy_product
-- ----------------------------
BEGIN;
INSERT INTO `easybuy_product` VALUES ('733', '香奈儿', '订单', '152', '94', '548', '654', '655', '27A1789ED5764D82A5506DF3DC3933F9.jpg', '0'), ('734', '洗面奶', '', '152', '995', '548', '654', '655', 'D6C9BD438C5643D6B1A6C52E5426FE22.jpg', '0'), ('735', '啫喱水', '', '152', '998', '548', '654', '655', '1A836D2B3A3348DDAB19807E6CEA8028.jpg', '0'), ('736', '香水5852', '', '152', '1000', '548', '654', '655', '4D9499BAD92A42D291094E797BA2EA3F.jpg', '0'), ('737', '香水', '', '152', '111', '548', '654', '655', 'A9924F9DB68B4DF99FDBF05902075AF0.jpg', '0'), ('738', '润肤露', '', '45', '109', '548', '654', '655', '3B059EDB5237407980458CE9EA9D3204.jpg', '0'), ('739', '洁面装', '', '156', '99', '548', '654', '655', 'A62C6DF55116440CA3DE9DB37901ED4F.jpg', '0'), ('740', '电饭锅', '', '158', '100', '628', '656', '659', '40C3B76BA31246618E3CFC8723D33517.jpg', '0'), ('741', '婴儿喂奶装', '', '569', '100', '632', '637', '653', '401004B3D47C4C6FB1BC5EF19C21FC77.jpg', '0'), ('742', '坚果套餐', '', '158', '1000', '660', '661', '662', 'E03D74145A034F6D909879829CB99D80.jpg', '0'), ('743', '超甜蜜崭', '', '589', '1000', '660', '661', '663', '7121E55099FC477680B1229205CE3D29.jpg', '0'), ('744', '华为2566', '', '589', '1000', '670', '671', '672', 'F24B4140A2284B3788A38F3B5AD1809A.jpg', '0'), ('745', '荣耀3C', '', '589', '100', '670', '671', '672', 'F3921E12552A4D0AA3F75467B146A959.jpg', '0'), ('746', '小米手环', '', '963', '100', '670', '674', '675', '72F75A371B0B4C26A7F72FAAEF96FC68.jpg', '0'), ('747', '华为2265', '', '896', '1000', '670', '671', '673', '161F355A8A8549BA8F7F4CE3B4F07E40.jpg', '0'), ('748', '越南坚果', '', '520', '1000', '660', '661', '662', 'CBC98D3C9E544830821632F5C313D93E.jpg', '0'), ('749', '日本进口马桶', '', '5866', '100', '628', '657', '0', 'A5AF40825E6940B2A59A040100E181A8.jpg', '0'), ('750', '联想Y系列', '', '569', '1000', '670', '690', '691', '956DB0BEC41B41B8A06C05C950130E23.jpg', '0'), ('751', '脑白金1号', '', '589', '1000', '676', '677', '680', '66E96AF9E9714A5C9EA901811173D662.jpg', '0'), ('752', '莫里斯按', '', '589', '1000', '676', '678', '0', 'A7436BC607E74C81B392DCFE69D4AEAB.jpg', '0'), ('753', '三鹿好奶粉', '', '859', '100', '676', '679', '0', '3C465E7B8A324A8DA2A2EEE202E36166.jpg', '0'), ('754', '儿童牛奶', '', '5896', '100', '676', '679', '0', 'D1AC9AE71ED348FA8D880FD4279D3422.jpg', '0'), ('755', '软沙发', '', '8596', '99', '628', '696', '0', 'ED7921DE40FC47E18365754709A21194.jpg', '0'), ('756', '收纳盒', '', '5966', '100', '628', '696', '0', 'DB86CA25CA4F4B4AA906F46BE542C6A6.jpg', '0'), ('757', '洗衣液', '', '58', '1000', '628', '696', '0', 'E6CCDC343ACC471C908E9748776C6421.jpg', '0'), ('758', '红短沙发', '', '596', '123', '628', '696', '0', 'BD5C77465DC2466BBCE7F95FB9764392.jpg', '0'), ('759', '新西兰奶粉', '', '5896', '100', '676', '679', '0', '9ED375098D42497B8FC33167E06D0EE8.jpg', '0'), ('760', '婴儿车', '', '11000', '100', '681', '682', '687', '1DBC0930641D43C29D74A9E1B40FEEBB.jpg', '0'), ('761', '夏款婴儿车', '', '963', '100', '681', '682', '688', '16290C4DBEAC4F00A636667019621468.jpg', '0'), ('762', '抗压旅行箱', '', '569', '1000', '681', '683', '685', '272CC434BE7A4469AB0E7882BD1A85FF.jpg', '0'), ('763', '透明手提箱', '', '8596', '1000', '681', '683', '684', 'EAA8E66259BF4239B4A2237B62520EF1.jpg', '0'), ('764', '婴儿果粉', '', '5896', '1000', '660', '661', '662', '08BE30BF7B5F4930B0093D8CC4056057.jpg', '0'), ('765', '椰子粉', '', '5963', '1000', '660', '661', '662', '9C006B8BD1AD45398F474A8471ADC50B.jpg', '0'), ('766', '坚果蛋糕', '', '200', '100', '660', '661', '663', '2E5A16E21E0640E0BAE03E9B995DCD28.jpg', '0'), ('767', '编制手提箱', '', '5896', '1000', '681', '682', '688', '2E1D2A5E65A94FEEA17C72E47C530057.jpg', '0'), ('768', '纸箱', '', '5896', '100', '681', '682', '687', '443E5A4122064209AFE89250179A2FF0.jpg', '0'), ('769', '健胃液', '', '152', '1000', '676', '679', '0', '30B5547CD7384DAA8A2F4F4D8C0BBF89.jpg', '0'), ('770', '联想NTC', '', '8596', '100', '670', '671', '673', '48BC371A85A548B7A7589E3F542D911D.jpg', '0');
COMMIT;

-- ----------------------------
-- Table structure for `student_info`
-- ----------------------------
DROP TABLE IF EXISTS `student_info`;
CREATE TABLE `student_info` (
`id`  int(10) UNSIGNED NOT NULL AUTO_INCREMENT ,
`stu_name`  varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '学生姓名' ,
`stu_gender`  char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '性别' ,
`stu_age`  int(11) NULL DEFAULT NULL COMMENT '性别' ,
`stu_birth_day`  datetime NULL DEFAULT NULL COMMENT '出生日期' ,
`classes_id`  int(11) NULL DEFAULT NULL COMMENT '班级id' ,
`hobby`  varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '爱好' ,
PRIMARY KEY (`id`)
)
ENGINE=InnoDB
DEFAULT CHARACTER SET=utf8 COLLATE=utf8_general_ci
AUTO_INCREMENT=62

;

-- ----------------------------
-- Records of student_info
-- ----------------------------
BEGIN;
INSERT INTO `student_info` VALUES ('14', '马六', '男', '12', '2021-04-20 00:00:00', '4', null), ('15', '张三', '男', '12', '2021-04-09 00:00:00', '1', null), ('16', '张三', '女', '2', '2021-04-23 00:00:00', '1', null);
COMMIT;

-- ----------------------------
-- Auto increment value for `acc_info`
-- ----------------------------
ALTER TABLE `acc_info` AUTO_INCREMENT=8;

-- ----------------------------
-- Auto increment value for `category_info`
-- ----------------------------
ALTER TABLE `category_info` AUTO_INCREMENT=697;

-- ----------------------------
-- Auto increment value for `classes_info`
-- ----------------------------
ALTER TABLE `classes_info` AUTO_INCREMENT=5;

-- ----------------------------
-- Auto increment value for `easybuy_order`
-- ----------------------------
ALTER TABLE `easybuy_order` AUTO_INCREMENT=4;

-- ----------------------------
-- Auto increment value for `easybuy_order_detail`
-- ----------------------------
ALTER TABLE `easybuy_order_detail` AUTO_INCREMENT=10;

-- ----------------------------
-- Auto increment value for `easybuy_product`
-- ----------------------------
ALTER TABLE `easybuy_product` AUTO_INCREMENT=771;

-- ----------------------------
-- Auto increment value for `student_info`
-- ----------------------------
ALTER TABLE `student_info` AUTO_INCREMENT=62;
